<%--
    Document   : temp
    Created on : Oct 4, 2012, 4:10:02 PM
    Author     : MinhThang
--%>

<%@page import="org.apt.connectDB.MyConnect"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.Connection"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>National Level Paper Presentation</title>
        <link href="style/css/transdmin.css" rel="stylesheet" type="text/css" media="screen" />
<!--[if IE 6]><link rel="stylesheet" type="text/css" media="screen" href="style/css/ie6.css" /><![endif]-->
<!--[if IE 7]><link rel="stylesheet" type="text/css" media="screen" href="style/css/ie7.css" /><![endif]-->

<!-- JavaScripts-->
<script type="text/javascript" src="style/js/jquery.js"></script>
<script type="text/javascript" src="style/js/jNice.js"></script>
    </head>
    <body>
        <%
                           if(session.getAttribute("AdminUser")==null || session.getAttribute("AdminUser").toString()==""){
                                response.sendRedirect("/Admin/adminlogin.jsp");
                           }
                        %>
        <div id="wrapper">
            <h1><a href="#"><span>Admin Paper Presentation</span></a></h1>
            <div><%@include file="Template/header.jsp" %></div>
            <div id="containerHolder">
                      <div id="sidebar">
                	<ul class="sideNav">
                            <li class="limenu"><a href="list_lecture.jsp"  class="active">List lecture</a></li>
                            <li class="limenu"><a href="create_lecture.jsp">Create a lecture</a></li>
                            <li class="limenu"><a href="list_author_lecture.jsp">List Author</a></li>
                            <li class="limenu"><a href="create_author_lecture.jsp">Create author</a></li>
                            <li class="limenu"><a href="create_lecture_event.jsp">Create Lecture event</a></li>
                            <li class="limenu"><a href="event_and_lecture.jsp">Event and lecture</a></li>
                        </ul>
                    <!-- // .sideNav -->
                        </div>
                    <h2><a href="#">Seminar >></a> <a href="#" class="active">Seminar detail</a></h2>
                <div id="main">
                    <form action="" class="jNice">
			<%
                        //display data by ID
                        Connection conn=null;
                        PreparedStatement ps=null;
                        String sql="Select * from LectureEvent where EventID=?";
                        ResultSet rs=null;
                        try{
                            conn=MyConnect.getConnection();
                            ps=conn.prepareCall(sql);
                            ps.setInt(1, Integer.parseInt(request.getParameter("ID")));
                            rs=ps.executeQuery();
                            while(rs.next()){
                                boolean status=rs.getBoolean("Status");
                                String tus="Active";
                                if(status==true){
                                    tus="Un-Active";
                                }
                                %>
                                <table>
                                    <tr>
                                        <td style="font-size: 1.5em;"><b><%=rs.getString("EventName").toString()%></b></td>
                                    </tr>
                                    <tr>
                                        <td><img src="../images/<%=rs.getString("Image").toString()%>" width="100" height="120"/></td>
                                    </tr>
                                    <tr>
                                        <td><b><%=rs.getString("Content").toString()%></b></td>
                                    </tr>
                                    <tr>
                                        <td>Location :<%=rs.getString("Location").toString()%></td>
                                    </tr>
                                    <tr>
                                        <td>Start hour :<%=rs.getString("Start").toString()%></td>
                                    </tr>
                                    <tr>
                                        <td>End hour :<%=rs.getString("End").toString()%></td>
                                    </tr>
                                    <tr>
                                        <td>Current join :<%=rs.getString("CurrentJoin").toString()%></td>
                                    </tr>
                                    <tr>
                                        <td>Max join :<%=rs.getString("MaxJoin").toString()%></td>
                                    </tr>
                                    <tr>
                                        <td>Price :<%=rs.getString("PriceJoin").toString()%></td>
                                    </tr>
                                    <tr>
                                        <td>Status : <%=tus%></td>
                                    </tr>
                                </table>

                                <%
                            }
                        }catch(Exception e)
                        {
                            e.printStackTrace();
                        }
                        %>
                    </form>
                </div>
                <!-- // #main -->
                <div class="clear"></div>
                </div>
            </div>
    </body>
</html>
